Using above script, we will create a table called STUDENT, with fields of STUDENT_ID, STUDENT_NAME and STUDENT_STATUS. Following codes, we insert each unique value into the STUDENT table. If you noticed on the STUDENT_ID field, there is a reserved keyword call UNIQUE. This keyword tell Personal SQL compiler to assign Primary Key to this particular Key. <br>
<br>
Once you done entered the script into the text box, click the RUN button or press the F5 key to execute the codes. A result window will appear if the compilation of those codes is successful. If you get an error message, please check the codes you have pasted. The result window will list all the executed codes and its result.<br>
<br>
We now have a new table together with its contents to work on. <br>
<br>
Click the <b>View Menu</b> of the <a href="#mainwin">Main Window</a>, choose the
<a href="#datexpwin"> DATABASE EXPLORER / DATA STRUCTURE WINDOW</a>. A new window will pop-out and listing the tables and its fields that we have just created.<br>
<br>
Now we are ready to go to the next steps in this tutorial. Before that, click on the
<b> FILE MENU</b> and choose new script. A message box will pop-out asking whether you wish to
<b> SAVE</b> the script. It is recommended for you to save it for later references. Save it as script1.pst. <br>
<br>
Once you that, a message box will appear to confirm the clear the current contents in the SQL text box. Go ahead and click
YES.<br>
<br>
Click here to go to next level û <a href="#viewquery"> Viewing Query Results</a></font></li>
</ol>
<p> </p>
<hr>
<p align="center"><font face="Tahoma" size="2"><b><a name="viewquery"></a>HOW TO ::
<p align="left"><b><font face="Tahoma" size="1" color="#000080">Basic tutorial guidelines on how to viewing query result</font></b><font face="Tahoma" size="2"><br>
<br>
Before we begin, we already have a table STUDENT created in previous tutorial section. If you missed it, please refer back to the
<a href="#newquery"> Creating New Query Section</a>.<br>
<br>
To continue, copy the following code to the SQL Code Text Box and press the F5 Key after that. <br>
<font color="#000080">SELECT * FROM STUDENT;</font><br>
<br>
Once you execute the code, a result window will appear listing the each field contents listed under table STUDENT.<br>
<br>
Type or copy the following code and put it under the first code we just execute<br>
<font color="#000080">SELECT STUDENT_ID, STUDENT_NAME FROM STUDENT;<br>
SELECT STUDENT_NAME, STUDENT_STATUS FROM STUDENT;<br>
SELECT * FROM STUDENT WHERE STUDENT_ID = 2;<br>
SELECT * FROM STUDENT WHERE STUDENT_NAME = æJohn DenverÆ</font><br>
<br>
Click the <b> RUN BUTTON</b> or <b> F5</b> key to execute the following codes.<br>
<br>
A new result window will appear with result from the codes you entered. From the result, you will have 5 different successful execute SQL code and its results.<br>
<br>
If you wish to save the result, click the <b> SAVE BUTTON</b>.<br>
If you wish to print it, click the <b> PRINT BUTTON</b></font></p>
</blockquote>
<p align="left"> </p>
<hr>
<p align="left"> </p>
<p align="center"><font face="Tahoma" size="2"><b><a name="getconn"></a>HOW TO ::
CONNECTING TO AN ODBC / ISAM DATABASE [<a href="#top">top</a>]</b></font></p>
<ol>
<li>
<p align="left"><font face="Tahoma" size="2">Launch the ODBC/ISAM
Connection Window.</font></li>
<li>
<p align="left"><font face="Tahoma" size="2">You have 2 choices, you
can connect to PSQL default database or attempt to make connection
<td width="452" valign="top" align="left" bgcolor="#FFFFFF" bordercolor="#000000"><font size="2" face="Tahoma">Abbreviation of Open DataBase Connectivity, a standard database access method developed by Microsoft Corporation. The goal of ODBC is to make it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data. ODBC manages this by inserting a middle layer, called a database driver , between an application and the DBMS. The purpose of this layer is to translate the application's data queries into commands that the DBMS understands. For this to work, both the application and the DBMS must be ODBC-compliant -- that is, the application must be capable of issuing ODBC commands and the DBMS must be capable of responding to them. Since version 2.0, the standard supports SAG SQL. </font></td>
<td width="452" valign="top" align="left" bgcolor="#FFFFFF" bordercolor="#000000"><font size="2" face="Tahoma">Abbreviation for Indexed Sequential Access Method, a method for managing how a computer accesses records and files stored on a hard disk. While storing data sequentially, ISAM provides direct access to specific records through an index. This combination results in quick data access regardless of whether records are being accessed sequentially or randomly. <br>
<br>
There are a number of products that provide basic ISAM access for different operating systems and program languages. </font></td>
SYSTEM TROUBLESHOOTING FAQs [<a href="#top">top</a>] </b></font>
<p><font face="Tahoma" size="2" color="#000080"><b>Why I cannot run after I installed the program on the network?<br>
</b>The system administrator to prevent unauthorized user, deleting or damaging the computer files may have disabled Computer attached to the network. Usually the system admin prefers to disable the Windows system directory. Since Personal SQL need to access the directory while running, prevent it may result failure. Please check with your system administrator.You may need to update to the latest system installer.
Please see the <a href="#installreq">system requirements</a> section on
how to get the entire latest PSQL software companions. <br>
<br>
<b>Why as soon as I installed, the program would run, and give an error message</b><br>
Probably the installation package files is corrupted. Please download a new one, and then try again.<br>
<br>
<b>When I try to run the program, it gave an error message ôSystem Errorö</b><br>
This tells you that your registry system is corrupted or someone tampered with registry system. Please uninstall the program before attempt to reinstall it. The program should be OK to go after you reinstall. If you own a registered version, please copy you name and key for later use, to undo the unregistered version. Its recommend you uninstall the current program in order to give new installation a clean environment.<br>
<br>
<b>Everything are fine except when I try to do the queries, instead giving me result if give me errors although I am positive my code is syntax error free.</b><br>
This problem usually occurs when the PSQLJET file dynamic lick library does not communicate very efficient with Window 98/NT Jet Data. If you are using Win95, it will not work because this program is designed to run under WIN98/NT4.0 and above version. However if you run under WIN98/NT4.0, please run the
<a href="#installreq"> MDAC_TYP.EXE</a> stored under Personal SQL directory. This is will update your system with the latest Jet Data. <br>
<br>
<b>I have already installed the MDAC_TYP.EXE; still the program is not working properly.</b><br>
Run the Dcomp98.exe under Personal SQL program directory, and then install the
<a href="#installreq"> MDAC_TYP.EXE</a><br>
<br>
<b>I did install both Dcomp98 and MDAC_TYP files, and its still give the same problem</b><br>
Please reinstall the Personal SQL program. If you own a registered version, please copy you name and key for later use, to undo the unregistered version. Its recommend you uninstall the current program in order to give new installation a clean environment.<br>
<br>
<b>What if all questions above is not the answer IÆm looking for</b><br>
You can forward the question online. The response may take up to 48 hour depending on the task need to be solved. If the question is forward in between 9am û 4pm CST and the question is straight forward, you might get the feedback within 1 to 2 hours.
Please also go to the <a href="http://www.azril.com/azrilstudio/supportmail.asp" target="_blank"> http://www.azril.com/azrilstudio/supportmail.asp</a> to forward you questions.</font>
